Network PC/Network PC.iso/amiga utilities/applications/accounts/easycalc2.0f/examples/example.calc

EasyCalc Spreadsheet file | 1997-11-20 | 3.0 KB | 104 lines

EASY30HED1
#'EasyCalc 2.0 - Example Worksheet 2
'Other EasyCalc functions:
'Function Example
"Result
'=@ASIN(0.1)
=@ASIN(0.1)
'=@ATAN(0.1)
=@ATAN(0.1)
!'=@AVG(B6:B9) OR =@AVERAGE(B6:B9)
=@AVG(B6:B9)
'=@CINT(1.4)
=@CINT(1.4)
'=@COLS(A1:C1)
=@COLS(A1:C1)
'=@ABS(-50)
=@ABS(-50)
'=@ACOS(0.1)
=@ACOS(0.1)
'=@COS(0.7)
=@COS(0.7)
'=@COSH(0.7)
=@COSH(0.7)
'=@COUNT(A6:B14)
=@COUNT(A6:B14)
'=@DATE(95,3,2)
=@DATE(95,3,2)
    '=@EXP(3)
=@EXP(3)
'=@FALSE
=@FALSE
'=@FIX(1.7)
=@FIX(1.7)
%'=@IF(B18=@FALSE, "NOT TRUE", "TRUE")
$=@IF(B18=@FALSE, "NOT TRUE", "TRUE")
'=@INDEX(A13:B18,1,0)
=@INDEX(A13:B18,1,0)
'=@INT(1.7)
=@INT(1.7)
'=@ISNUM(B18)
=@ISNUM(B18)
'=@ISSTR(B18)
=@ISSTR(B18)
'=@LINK("STRINGS.CALC>B10")
=@LINK("STRINGS.CALC>B14")
'<- Press HELP
'=@LOG10(5)
=@LOG10(5)
    '=@LOG(2)
=@LOG(2)
'=@MAX(B21:B27)
=@MAX(B21:B27)
'=@MIN(B21:B27)
=@MIN(B21:B27)
'=@MOD(10,3)
=@MOD(10,3)
'=@NEWVAT(100,1)
=@NEWVAT(100,1)
    '=@NOT(1)
=@NOT(1)
'=@NOW
=@NOW
'=@PI
'=@RAD(90)
    =@RAD(90)
'=@DEG(1.5707)
=@DEG(1.57079632)
'=@RAND
=@RAND
'=@RND(100)
=@RND(100)
'=@ROWS(A26:B34)
=@ROWS(A26:B34)
'=@SIGN(-56)
=@SIGN(-56)
'=@SIN(0.5)
=@SIN(0.5)
'=@SINH(0.5)
=@SINH(0.5)
'=@SQR(49) OR =@SQRT(49)
    =@SQR(49)
'=@SUM(B34:B43)
=@SUM(B34:B43)
'=@TAN(0.5)
=@TAN(0.5)
'=@TANH(0.5)
=@TANH(0.5)
'=@TIME(16,43,23)
=@TIME(16,43,23)
'=@TODAY
=@TODAY
'=@TRUE
=@TRUE
'=@VAT(100)
=@VAT(100)
'[PRESS HELP HERE]
STRINGS.CALC needs to be loaded for this to evaluate. If the
link worksheet can't be found, then 0 is returned. No error
messages are generated unless the string is invalid.NOTE
To get detailed information on any function displayed here,
press RETURN while over a cell function, then move the
cursor over the '@' symbol of the function you are interested in.
Then press HELP.PALL